/*
 Navicat Premium Data Transfer

 Source Server         : 本机
 Source Server Type    : MySQL
 Source Server Version : 50714
 Source Host           : localhost:3306
 Source Schema         : caoxingfen

 Target Server Type    : MySQL
 Target Server Version : 50714
 File Encoding         : 65001

 Date: 17/04/2022 21:19:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_class
-- ----------------------------
DROP TABLE IF EXISTS `t_class`;
CREATE TABLE `t_class` (
  `class_id` int(10) NOT NULL AUTO_INCREMENT,
  `class_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `collage_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_class
-- ----------------------------
BEGIN;
INSERT INTO `t_class` (`class_id`, `class_name`, `collage_id`) VALUES (1, '云计算2021', 1);
INSERT INTO `t_class` (`class_id`, `class_name`, `collage_id`) VALUES (2, '云计算2022', 1);
INSERT INTO `t_class` (`class_id`, `class_name`, `collage_id`) VALUES (3, '云计算1921', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_collage
-- ----------------------------
DROP TABLE IF EXISTS `t_collage`;
CREATE TABLE `t_collage` (
  `collage_id` int(10) NOT NULL AUTO_INCREMENT,
  `collage_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`collage_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_collage
-- ----------------------------
BEGIN;
INSERT INTO `t_collage` (`collage_id`, `collage_name`, `school_id`) VALUES (1, '信息工程学院', 1);
INSERT INTO `t_collage` (`collage_id`, `collage_name`, `school_id`) VALUES (2, '环境工程学院', 1);
INSERT INTO `t_collage` (`collage_id`, `collage_name`, `school_id`) VALUES (3, '生命健康学院', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_mount_sorce
-- ----------------------------
DROP TABLE IF EXISTS `t_mount_sorce`;
CREATE TABLE `t_mount_sorce` (
  `mount_sorce_id` int(20) NOT NULL AUTO_INCREMENT,
  `project` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `project_sorce` double NOT NULL DEFAULT '0',
  `create_date` datetime DEFAULT NULL,
  `project_type_id` int(10) DEFAULT NULL,
  `user_id` int(20) DEFAULT NULL,
  PRIMARY KEY (`mount_sorce_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of t_mount_sorce
-- ----------------------------
BEGIN;
INSERT INTO `t_mount_sorce` (`mount_sorce_id`, `project`, `project_sorce`, `create_date`, `project_type_id`, `user_id`) VALUES (1, '读书笔记', 5, '2022-04-17 00:00:00', 5, 2);
INSERT INTO `t_mount_sorce` (`mount_sorce_id`, `project`, `project_sorce`, `create_date`, `project_type_id`, `user_id`) VALUES (2, '读书笔记', 5, '2022-04-17 00:00:00', 5, 2);
COMMIT;

-- ----------------------------
-- Table structure for t_permssion
-- ----------------------------
DROP TABLE IF EXISTS `t_permssion`;
CREATE TABLE `t_permssion` (
  `user_permssion_id` int(5) NOT NULL AUTO_INCREMENT,
  `user_permssion_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`user_permssion_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of t_permssion
-- ----------------------------
BEGIN;
INSERT INTO `t_permssion` (`user_permssion_id`, `user_permssion_name`) VALUES (1, '学校管理员');
INSERT INTO `t_permssion` (`user_permssion_id`, `user_permssion_name`) VALUES (2, '学院管理员');
INSERT INTO `t_permssion` (`user_permssion_id`, `user_permssion_name`) VALUES (3, '班级管理员');
INSERT INTO `t_permssion` (`user_permssion_id`, `user_permssion_name`) VALUES (4, '普通用户');
COMMIT;

-- ----------------------------
-- Table structure for t_project_type
-- ----------------------------
DROP TABLE IF EXISTS `t_project_type`;
CREATE TABLE `t_project_type` (
  `project_type_id` int(10) NOT NULL AUTO_INCREMENT,
  `project_type_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`project_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of t_project_type
-- ----------------------------
BEGIN;
INSERT INTO `t_project_type` (`project_type_id`, `project_type_name`) VALUES (1, '升旗体育锻炼');
INSERT INTO `t_project_type` (`project_type_id`, `project_type_name`) VALUES (2, '课堂纪律');
INSERT INTO `t_project_type` (`project_type_id`, `project_type_name`) VALUES (3, '青年志愿者');
INSERT INTO `t_project_type` (`project_type_id`, `project_type_name`) VALUES (4, '宿舍卫生');
INSERT INTO `t_project_type` (`project_type_id`, `project_type_name`) VALUES (5, '各类竞赛');
INSERT INTO `t_project_type` (`project_type_id`, `project_type_name`) VALUES (6, '读书笔记');
COMMIT;

-- ----------------------------
-- Table structure for t_school
-- ----------------------------
DROP TABLE IF EXISTS `t_school`;
CREATE TABLE `t_school` (
  `school_id` int(10) NOT NULL AUTO_INCREMENT,
  `school_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`school_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_school
-- ----------------------------
BEGIN;
INSERT INTO `t_school` (`school_id`, `school_name`) VALUES (1, '南京科技职业学院');
INSERT INTO `t_school` (`school_id`, `school_name`) VALUES (2, '南京化工职业技术学院');
INSERT INTO `t_school` (`school_id`, `school_name`) VALUES (3, '南京交通职业技术学院');
COMMIT;

-- ----------------------------
-- Table structure for t_term_date
-- ----------------------------
DROP TABLE IF EXISTS `t_term_date`;
CREATE TABLE `t_term_date` (
  `term_date_id` int(20) NOT NULL AUTO_INCREMENT,
  `term_date_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`term_date_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of t_term_date
-- ----------------------------
BEGIN;
INSERT INTO `t_term_date` (`term_date_id`, `term_date_name`) VALUES (1, '20届上半学期');
COMMIT;

-- ----------------------------
-- Table structure for t_term_sorce
-- ----------------------------
DROP TABLE IF EXISTS `t_term_sorce`;
CREATE TABLE `t_term_sorce` (
  `term_sorce_id` int(20) NOT NULL AUTO_INCREMENT,
  `term_sorce` double DEFAULT NULL,
  `user_id` int(20) DEFAULT NULL,
  `term_date_id` int(20) DEFAULT NULL,
  `term_sorce_project` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `term_sorce_project_sorce` double DEFAULT NULL,
  PRIMARY KEY (`term_sorce_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of t_term_sorce
-- ----------------------------
BEGIN;
INSERT INTO `t_term_sorce` (`term_sorce_id`, `term_sorce`, `user_id`, `term_date_id`, `term_sorce_project`, `term_sorce_project_sorce`) VALUES (1, 75, 2, 0, 'jiafen', 4);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `user_id` int(20) NOT NULL AUTO_INCREMENT,
  `stu_number` int(30) DEFAULT NULL,
  `usernick` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `is_delete` int(5) DEFAULT '2' COMMENT '1为删除，2为保留',
  `delete_time` datetime DEFAULT NULL,
  `last_login_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `user_permssion_id` int(5) DEFAULT NULL,
  `class_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` (`user_id`, `stu_number`, `usernick`, `password`, `is_delete`, `delete_time`, `last_login_time`, `create_time`, `user_permssion_id`, `class_id`) VALUES (1, 2006450119, '任奕铮', '91b4d142823f7d20c5f08df69122de43f35f057a988d9619f6d3138485c9a203', 2, NULL, NULL, '2002-09-04 00:00:00', 3, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
